﻿-- Make the Issue-To fields nullable for now since they seem redundant with the applicant.
-- The alternate applicant (custodian) is also optional on the form.
IF OBJECT_ID('dbo.Grants', 'U') IS NOT NULL
BEGIN
    ALTER TABLE Grants ALTER COLUMN IssueToPersonID bigint NULL
    ALTER TABLE Grants ALTER COLUMN IssueToAddressID bigint NULL
    ALTER TABLE Grants ALTER COLUMN DeliverToPersonID bigint NULL
    ALTER TABLE Grants ALTER COLUMN DeliverToAddressID bigint NULL
END
